Setting up your Inventory Master File

The Inventory master file within MDS (which is duplicated in MRF) contains all of your stock information – whether coil stock, normal resale type stock lines or manufactured items.

Warning You should check the quantity on hand and average cost of any existing MRF items regularly. A negative figure for either is unacceptable. When stock on hand is negative, average cost will be calculated as zero. In this case, you need to adjust the stock on hand quantity to make it positive again.

When you are setting up your items for MRF, you need to create the following item types:

1. Store items:

These are standard buy-it, store-it, sell-it items such as screws, silicone, skylights, fasteners, insulation, etc.

2. Manufactured items:

Manufactured items are items made from other raw material items such as coil stock, e.g. rolled stock or flashing. They may be made to order or for stock. At production time, you can substitute the default coil stock with either offcuts, other coil stock or from a previously manufactured finished item.

3. Coil items:

Coil stock items are raw coil stock from which manufactured items are made. They are setup the same as normal stock items with the exception of the purchasing details. You need to ensure that purchasing conversion information is setup correctly so that coils can be ordered in tonnes but received as the anticipated lineal metres, and that FIFO/serial number tracking is turned on.

4. Waste items:

Micronet can accumulate waste during the job completion process for coil stock that is going to be thrown away or sent to the recycler. You can have more than one waste item setup. A waste item can be setup with a part number starting with WASTEXXX where XXXX can be any trailing characters you want to add.

5. Offcut items:

Micronet can accumulate offcuts (in square metres only) during the job completion process for coil stock that is going to be retained and used in future jobs. Offcuts usually refers to flashing offcuts. You can have more than one offcut item setup. An offcut item can be setup with a part number starting with SCRAPXXXX where XXXX can be any trailing characters you want to add.

6. Excess items:

These are normal stock lines that can be posted against where you have made more than the customer ordered, or where you have made extra for stock. For example, you might have made some fence panels or roofing stock rather than shut the machine down and change over with only a small amount of coil stock left on the reel.

7. Seconds items:

These are second quality rolled products which go back into stock. Micronet treats them the same as excess items, except on the Yield Report where they are added to the on hand quantity of the nominated stock item.